ORA-01758 when trying to alter table

If you are trying to add a new Not NULL columns to a table and you get the following error: ORA-01758: table must be empty to add mandatory (NOT NULL) column Since the values in the new column are null (after all, you just added the column) the new constraint can not be satisfied. There … Continue reading ORA-01758 when trying to alter table